--
-- For development - Move to db schema and blank this file when dev complete.
-- 

-- DROP TABLE IF EXISTS [MediaDevice];

CREATE TABLE IF NOT EXISTS [MediaDevice] (
[MediaDeviceID] INTEGER  PRIMARY KEY AUTOINCREMENT NOT NULL,
[Guid] NVARCHAR(255) UNIQUE NOT NULL,
[Enabled] INTEGER DEFAULT 0,
[VolumeName] NVARCHAR(255) NULL,
[BaseFolder] NVARCHAR(255) NULL,
[EjectOption] INTEGER DEFAULT 0,
[OrganizationOption] INTEGER DEFAULT 0,
[TransferOption] INTEGER DEFAULT 0
);

-- UPDATE [Episode] 